Scheduling Frequencies
Access Scheduling Frequencies by clicking the Scheduling Frequencies link that is on the Administration page, Processes menu.
To create a new frequency, click the
at the top of the page. An
Add Schedule Frequency dialog opens. Enter a
Description and
Schedule Frequency. Use the frequency format that
is described in a section below. Click
Save when finished.
The Schedule Frequency form allows the system manager to define a set of frequencies/repeat intervals that are to be used with the framework to suit their own operational requirements.
Once a frequency is created, a job can be scheduled to run at a particular date and time if required or at repeat intervals if required.
- Description (Required) - Enter the description of the frequency to be defined.
- Scheduler Frequency (Optional) - The Scheduler frequency, entered in the format shown below. These frequencies are defined for use by the Oracle scheduler. Some examples are shown in the screen shot. Any frequency or interval can be specified using this format.
- Intervals (Read-Only) - The interval specified will be displayed in minutes.
- Next Schedule Date (Read-Only) - The next scheduled date is displayed to show the effect of the frequency entered.
- Subsequent Date (Read-Only) - The subsequent scheduled date is displayed to show the effect of the frequency entered.
- Protected (Read-only switch) - Frequencies shipped by the system will be flagged as Protected and cannot be removed/amended.
Frequency Format - Examples
This list is intended as a series of examples and is not exhaustive.
- Execute every Friday: – FREQ=WEEKLY; BYDAY=FRI;
- Execute every other Friday: – FREQ=WEEKLY; INTERVAL=2; BYDAY=FRI;
- Execute on the last day of every month: – FREQ=MONTHLY; BYMONTHDAY-1;
- Execute on the next to last day of every month: – FREQ=MONTHLY; BYMONTHDAY-2;
- Execute on March 10th: – FREQ=YEARLY; BYMONTH=MAR; BYMONTHDAY=10;
- Execute every 10 days: – FREQ=DAILY; INTERVAL=10;
- Execute daily at 4, 5, and 6PM: – FREQ=DAILY; BYHOUR=16,17,18;
- Execute on the 15th day of every other month: – FREQ=MONTHLY; INTERVAL=2; BYMONTHDAY=15;
- Execute on the 29th day of every month: – FREQ=MONTHLY; BYMONTHDAY=29;
- Execute on the second Wednesday of each month: – FREQ=MONTHLY; BYDAY=2WED;
- Execute on the last Friday of the year: – FREQ=YEARLY; BYDAY=-1FRI;
- Execute every 50 hours: – FREQ=HOURLY; INTERVAL=50;
- Execute on the last day of every other month: – FREQ=MONTHLY; INTERVAL=2; BYMONTHDAY-1;
- Execute hourly for the first three days of every month: – FREQ=HOURLY; BYMONTHDAY=1,2,3;